<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed'); ?>

INFO  - 2011-05-24 14:52:59 --> [ 127.0.0.1] SELECT *
FROM (`usr_user_information`)
WHERE `username` = 'note'
AND `password` = 'note'<br/>
INFO  - 2011-05-24 14:52:59 --> [ 127.0.0.1] SELECT `permission`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-24 14:52:59 --> [note 127.0.0.1] SELECT `user_type`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-24 14:53:00 --> [note 127.0.0.1] SELECT *
FROM (`vr_ord_order`)
WHERE `order_status` = '1'
ORDER BY `order_received_date` desc, `po_id` asc<br/>
INFO  - 2011-05-24 14:53:00 --> [note 127.0.0.1] SELECT `supplier_id`, `supplier_name`
FROM (`crm_supplier_information`)<br/>
INFO  - 2011-05-24 14:53:00 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_order_status`)
ORDER BY CAST(order_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-24 14:55:09 --> [note 127.0.0.1] SELECT *
FROM (`usr_user_information`)
WHERE `username` = 'note'
AND `password` = 'note'<br/>
INFO  - 2011-05-24 14:55:11 --> [note 127.0.0.1] SELECT *
FROM (`usr_user_information`)
WHERE `username` = 'note'
AND `password` = 'note'<br/>
INFO  - 2011-05-24 15:02:37 --> [note 127.0.0.1] SELECT *
FROM (`usr_user_information`)
WHERE `username` = 'note'
AND `password` = 'note'<br/>
INFO  - 2011-05-24 15:02:37 --> [note 127.0.0.1] SELECT `permission`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-24 15:02:37 --> [note 127.0.0.1] SELECT `user_type`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-24 15:02:38 --> [note 127.0.0.1] SELECT *
FROM (`vr_ord_order`)
WHERE `order_status` = '1'
ORDER BY `order_received_date` desc, `po_id` asc<br/>
INFO  - 2011-05-24 15:02:38 --> [note 127.0.0.1] SELECT `supplier_id`, `supplier_name`
FROM (`crm_supplier_information`)<br/>
INFO  - 2011-05-24 15:02:38 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_order_status`)
ORDER BY CAST(order_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-24 15:03:12 --> [note 127.0.0.1] SELECT *
FROM (`vr_ord_order`)
WHERE `order_status` = '1'
ORDER BY `order_received_date` desc, `po_id` asc<br/>
INFO  - 2011-05-24 15:03:12 --> [note 127.0.0.1] SELECT `supplier_id`, `supplier_name`
FROM (`crm_supplier_information`)<br/>
INFO  - 2011-05-24 15:03:12 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_order_status`)
ORDER BY CAST(order_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-24 15:03:15 --> [note 127.0.0.1] SELECT *
FROM (`vr_ord_order`)
WHERE `order_status` = '1'
ORDER BY `order_received_date` desc, `po_id` asc<br/>
INFO  - 2011-05-24 15:03:15 --> [note 127.0.0.1] SELECT `supplier_id`, `supplier_name`
FROM (`crm_supplier_information`)<br/>
INFO  - 2011-05-24 15:03:15 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_order_status`)
ORDER BY CAST(order_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-24 15:03:16 --> [note 127.0.0.1] SELECT *
FROM (`crm_supplier_information`)
WHERE `supplier_id` = '20110511084111827'<br/>
INFO  - 2011-05-24 15:03:16 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_payment_term`)<br/>
INFO  - 2011-05-24 15:03:16 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_order_status`)
ORDER BY CAST(order_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-24 15:03:16 --> [note 127.0.0.1] SELECT *
FROM (`vr_ord_order`)
WHERE `supplier_name` = 'ซันสตีลกรุ๊ป จำกัด'<br/>
INFO  - 2011-05-24 15:03:41 --> [note 127.0.0.1] SELECT *
FROM (`crm_supplier_information`)
WHERE `supplier_id` = '20110511084111827'<br/>
INFO  - 2011-05-24 15:03:41 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_payment_term`)<br/>
INFO  - 2011-05-24 15:03:41 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_order_status`)
ORDER BY CAST(order_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-24 15:03:41 --> [note 127.0.0.1] SELECT *
FROM (`vr_ord_order`)
WHERE `supplier_name` = 'ซันสตีลกรุ๊ป จำกัด'<br/>
INFO  - 2011-05-24 15:03:42 --> [note 127.0.0.1] SELECT *
FROM (`vr_ord_order`)
WHERE `order_status` = '1'
ORDER BY `order_received_date` desc, `po_id` asc<br/>
INFO  - 2011-05-24 15:03:42 --> [note 127.0.0.1] SELECT `supplier_id`, `supplier_name`
FROM (`crm_supplier_information`)<br/>
INFO  - 2011-05-24 15:03:42 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_order_status`)
ORDER BY CAST(order_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-24 15:03:45 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-24 15:03:45 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-24 15:03:46 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-24 15:03:46 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-24 15:03:47 --> [note 127.0.0.1] select pf.coil_group_code 	,pf.thickness 	,pf.width 	,pf.product_dtl_id 	,pf.slit_date 	,pf.unit 	,pf.weight 	,( select program_code from prd_product_produce where coil_group_code = pf.coil_group_code and product_dtl_id = pf.product_dtl_id ) as program_code 	,( select ppi.program_code_ext 		from prd_program_information ppi, prd_product_produce pp 		where pp.coil_group_code = pf.coil_group_code 			and pp.product_dtl_id = pf.product_dtl_id 			and ppi.product_dtl_id = pf.product_dtl_id 			and ppi.program_code = pp.program_code 		limit 1 ) as program_code_ext from vr_prd_film pf where pf.populate_flag = 'N' order by slit_date desc<br/>
INFO  - 2011-05-24 15:03:47 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
ORDER BY `product_display_id` asc<br/>
INFO  - 2011-05-24 15:03:51 --> [note 127.0.0.1] SELECT *
FROM (`vr_ord_order`)
WHERE ( order_status = '1' OR order_status = '2')
ORDER BY `po_id`<br/>
INFO  - 2011-05-24 15:03:54 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `po_id` = 'OL17'
AND `coil_status` = '1'
ORDER BY `coil_lot_no` asc<br/>
INFO  - 2011-05-24 15:03:58 --> [note 127.0.0.1] SELECT `thickness`
FROM (`ord_order_information`)
WHERE `po_id` = 'OL17'<br/>
INFO  - 2011-05-24 15:03:58 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
WHERE `thickness_rep` = 2.65<br/>
INFO  - 2011-05-24 15:04:00 --> [note 127.0.0.1] SELECT `slit_spec_id`, `slit_thickness`, MIN(`remark`) AS remark
FROM (`prd_slit_specification`)
WHERE `slit_thickness` = 2.65
AND `product_dtl_id` IN ('0051') 
GROUP BY `slit_spec_id`
HAVING count(1) >= 1
ORDER BY `slit_thickness` asc<br/>
INFO  - 2011-05-24 15:04:02 --> [note 127.0.0.1] SELECT *
FROM (`prd_slit_specification`)
WHERE `slit_spec_id` = '70'<br/>
INFO  - 2011-05-24 15:04:02 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
WHERE `product_dtl_id` = '0051'<br/>
INFO  - 2011-05-24 15:04:02 --> [note 127.0.0.1] SELECT fr_prd_get_program_code('0051') as program_code<br/>
INFO  - 2011-05-24 15:04:02 --> [note 127.0.0.1] SELECT `program_code_ext`
FROM (`prd_program_information`)
WHERE `program_code` = 'PC000534'
AND `product_dtl_id` = '0051'
AND `program_status` = 1
LIMIT 1<br/>
INFO  - 2011-05-24 15:04:02 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
WHERE `product_dtl_id` = '0034'<br/>
INFO  - 2011-05-24 15:04:02 --> [note 127.0.0.1] SELECT fr_prd_get_program_code('0034') as program_code<br/>
INFO  - 2011-05-24 15:04:02 --> [note 127.0.0.1] SELECT `program_code_ext`
FROM (`prd_program_information`)
WHERE `program_code` = 'PC000535'
AND `product_dtl_id` = '0034'
AND `program_status` = 1
LIMIT 1<br/>
INFO  - 2011-05-24 15:04:03 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `po_id` = 'OL17'
AND `coil_status` = '1'
ORDER BY `coil_lot_no` asc<br/>
INFO  - 2011-05-24 15:04:03 --> [note 127.0.0.1] SELECT *
FROM (`prd_slit_specification`)
WHERE `slit_spec_id` = '70'<br/>
INFO  - 2011-05-24 15:04:03 --> [note 127.0.0.1] SELECT *
FROM (`prd_slit_specification`)
WHERE `slit_spec_id` = '70'<br/>
INFO  - 2011-05-24 15:04:03 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
WHERE `product_dtl_id` = '0051'<br/>
INFO  - 2011-05-24 15:04:03 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
WHERE `product_dtl_id` = '0034'<br/>
INFO  - 2011-05-24 15:04:03 --> [note 127.0.0.1] SELECT `coil_group_code`
FROM (`vr_prd_next_po_id`)
WHERE `po_id` = 'OL17'<br/>
INFO  - 2011-05-24 15:04:05 --> [note 127.0.0.1] SELECT *
FROM (`prd_slit_specification`)
WHERE `slit_spec_id` = '70'<br/>
INFO  - 2011-05-24 15:04:05 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
WHERE `product_dtl_id` = '0051'<br/>
INFO  - 2011-05-24 15:04:05 --> [note 127.0.0.1] SELECT fr_prd_get_program_code('0051') as program_code<br/>
INFO  - 2011-05-24 15:04:05 --> [note 127.0.0.1] SELECT `program_code_ext`
FROM (`prd_program_information`)
WHERE `program_code` = 'PC000534'
AND `product_dtl_id` = '0051'
AND `program_status` = 1
LIMIT 1<br/>
INFO  - 2011-05-24 15:04:05 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
WHERE `product_dtl_id` = '0034'<br/>
INFO  - 2011-05-24 15:04:05 --> [note 127.0.0.1] SELECT fr_prd_get_program_code('0034') as program_code<br/>
INFO  - 2011-05-24 15:04:05 --> [note 127.0.0.1] SELECT `program_code_ext`
FROM (`prd_program_information`)
WHERE `program_code` = 'PC000535'
AND `product_dtl_id` = '0034'
AND `program_status` = 1
LIMIT 1<br/>
INFO  - 2011-05-24 15:04:07 --> [note 127.0.0.1] select pf.coil_group_code 	,pf.thickness 	,pf.width 	,pf.product_dtl_id 	,pf.slit_date 	,pf.unit 	,pf.weight 	,( select program_code from prd_product_produce where coil_group_code = pf.coil_group_code and product_dtl_id = pf.product_dtl_id ) as program_code 	,( select ppi.program_code_ext 		from prd_program_information ppi, prd_product_produce pp 		where pp.coil_group_code = pf.coil_group_code 			and pp.product_dtl_id = pf.product_dtl_id 			and ppi.product_dtl_id = pf.product_dtl_id 			and ppi.program_code = pp.program_code 		limit 1 ) as program_code_ext from vr_prd_film pf where pf.populate_flag = 'N' order by slit_date desc<br/>
INFO  - 2011-05-24 15:04:07 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
ORDER BY `product_display_id` asc<br/>
INFO  - 2011-05-24 15:05:00 --> [note 127.0.0.1] SELECT *
FROM (`usr_user_information`)
WHERE `username` = 'note'
AND `password` = 'note'<br/>
INFO  - 2011-05-24 15:05:00 --> [note 127.0.0.1] SELECT `permission`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-24 15:05:00 --> [note 127.0.0.1] SELECT `user_type`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-24 15:05:01 --> [note 127.0.0.1] SELECT *
FROM (`vr_ord_order`)
WHERE `order_status` = '1'
ORDER BY `order_received_date` desc, `po_id` asc<br/>
INFO  - 2011-05-24 15:05:01 --> [note 127.0.0.1] SELECT `supplier_id`, `supplier_name`
FROM (`crm_supplier_information`)<br/>
INFO  - 2011-05-24 15:05:01 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_order_status`)
ORDER BY CAST(order_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-24 15:17:24 --> [note 127.0.0.1] SELECT *
FROM (`usr_user_information`)
WHERE `username` = 'note'
AND `password` = 'note'<br/>
INFO  - 2011-05-24 15:17:24 --> [note 127.0.0.1] SELECT `permission`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-24 15:17:24 --> [note 127.0.0.1] SELECT `user_type`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-24 15:17:37 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-24 15:17:37 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-24 15:17:41 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-24 15:17:41 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-24 15:17:46 --> [note 127.0.0.1] SELECT MAX(`mc_id`) AS mc_id
FROM (`mc_machine_info`)<br/>
INFO  - 2011-05-24 15:17:46 --> [note 127.0.0.1] INSERT INTO `mc_machine_info` (`mc_id`, `machine_name`, `status`, `record_change_by`, `record_change_date`) VALUES (1, 'CFU1', 1, 'note', '2011-05-24 15:17:46')<br/>
INFO  - 2011-05-24 15:17:47 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-24 15:17:47 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-24 15:17:48 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-24 15:17:50 --> [note 127.0.0.1] SELECT MAX(`machine_config_id`) AS machine_config_id
FROM (`mc_machine_config`)<br/>
INFO  - 2011-05-24 15:17:50 --> [note 127.0.0.1] INSERT INTO `mc_machine_config` (`machine_config_id`, `machine_config_name`, `status`, `record_change_by`, `record_change_date`) VALUES (1, 'TEST', 1, 'note', '2011-05-24 15:17:50')<br/>
INFO  - 2011-05-24 15:17:51 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-24 15:17:53 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-24 15:17:53 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-24 15:18:00 --> [note 127.0.0.1] SELECT `coil_group_code`
FROM (`prd_product_produce`)
WHERE `program_code` = 'PC000484'
AND `product_dtl_id` = '0026'<br/>
INFO  - 2011-05-24 15:18:00 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OM07_02'
AND `product_dtl_id` = '0026'<br/>
INFO  - 2011-05-24 15:18:00 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM07'<br/>
INFO  - 2011-05-24 15:18:00 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM07'<br/>
INFO  - 2011-05-24 15:18:00 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM07_02'
AND `program_code` = 'PC000484'
LIMIT 1<br/>
INFO  - 2011-05-24 15:18:00 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM07_02'
AND `product_dtl_id` = '0026'<br/>
INFO  - 2011-05-24 15:18:00 --> [note 127.0.0.1] SELECT DISTINCT `machine_by`
FROM (`prd_product_produce`)
WHERE `program_code` = 'PC000484'
LIMIT 1<br/>
INFO  - 2011-05-24 15:18:00 --> [note 127.0.0.1] SELECT *
FROM (`prd_program_information`)
WHERE `program_code` = 'PC000484'
AND `product_dtl_id` = '0026'
ORDER BY `processing_date` asc<br/>
INFO  - 2011-05-24 15:18:00 --> [note 127.0.0.1] SELECT `program_status`
FROM (`prd_program_information`)
WHERE `program_code` = 'PC000484'
AND `product_dtl_id` = '0026'
LIMIT 1<br/>
INFO  - 2011-05-24 15:18:00 --> [note 127.0.0.1] SELECT `program_code_ext`
FROM (`prd_program_information`)
WHERE `program_code` = 'PC000484'
AND `product_dtl_id` = '0026'
LIMIT 1<br/>
INFO  - 2011-05-24 15:18:01 --> [note 127.0.0.1] SELECT fr_prd_get_avg_weight('PC000484') as avg_weight<br/>
INFO  - 2011-05-24 15:18:01 --> [note 127.0.0.1] SELECT fr_prd_get_perct_grade_b('PC000484') as grade_b<br/>
INFO  - 2011-05-24 15:18:01 --> [note 127.0.0.1] SELECT fr_prd_get_avg_per_unit('PC000484', '0026') as cost<br/>
INFO  - 2011-05-24 15:18:01 --> [note 127.0.0.1] SELECT fr_prd_get_avg_cost_per_unit('PC000484', '0026') as cost_and_wage<br/>
INFO  - 2011-05-24 15:18:01 --> [note 127.0.0.1] SELECT `est_weight`
FROM (`prd_product_detail`)
WHERE `product_dtl_id` = '0026'
LIMIT 1<br/>
INFO  - 2011-05-24 15:18:01 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
WHERE `product_dtl_id` = '0026'<br/>
